A list of the specific data fields that can be imported is listed below in the order that the fields appear on the screen. For ease of import, the fields names are the same as those that appear as labels on the screen. Where a field has been marked as ‘required’ the import cannot be completed unless that data is supplied. Review Defining the Inventory form for more information on each field.
| Field | Required / Comment | Default Value if not imported |
|---|---|---|
| Part No |
|
|
| Description |
|
|
| Details | ||
| Classification | Must exist with tax rates and Product Pricing Group set | Default Classification |
| UPC | This is field Aux2 in the database. Inventory system setting Aux2Label determines the description label in each database | |
| Version | This is field Aux1 in the database. Inventory system setting Aux1Label determines the description label in each database | |
| Status | These are Normal, Discontinued, Deleted, Slow or Obsolete | Normal |
| Decimal | 0 | |
| Unit | ||
| Weight | 0.000000 | |
| Cubic Size | 0.000000 | |
| Kit Style | Options are None, BOM, Template, Kit, Kit (tax Override) | None |
| Sell Price | 0.00 | |
| RRP | 0.00 | |
| Sales Cost | 0.00 | |
| Direct Tax | 0.00 | |
| Secondary Cost | 0.00 | |
| Use Serial Nos |
|
|
| Allow Price Overrides |
|
|
| Ship With Physical Item |
|
|
| Sell Price Represents Tax Inclusive |
|
|
| Physical Item |
|
|
| Back Orderable |
|
|
| Product Type | This is field Category1ID in the database. Inventory system setting Category1 determines the description label in each database | Default - No Category |
| Purpose | This is field Category2ID in the database. Inventory system setting Category2 determines the description label in each database | Default - No Category |
| Material | This is field Category3ID in the database. Inventory system setting Category3 determines the description label in each database | Default - No Category |
| Finish | This is field Category4ID in the database. Inventory system setting Category4 determines the description label in each database | Default - No Category |
| Packaging | This is field Category5ID in the database. Inventory system setting Category5 determines the description label in each database | Default - No Category |
| Last Cost | 0.00 | |
| Minimum Markup GP % | 0.00 | |
| Order Enabled | Yes, No |
|
| Supplier Account No | If Order Enabled is Yes, then a valid supplier account number must be supplied | |
| Supplier Warehouse | ||
| Supplier Part No | If a supplier value is supplied and this field is not, the value updated into the database is the PartNo field | |
| Supplier Warehouse Home Cost | 0.00 | |
| Supplier Warehouse Foreign Cost | 0.00 | |
| Supplier Warehouse Delivery Days | 0 | |
| Supplier Warehouse Order Units | 0 |
Copyright © 2012 Jiwa Financials. All rights reserved.